SqlMap = {
    "list": "SELECT a.attendce_date,u.viewname,u.school_id,u.department,u.profession,a.not_attendce FROM attendce a INNER JOIN user u on a.user_id=u.id where a.not_attendce order by a.attendce_date desc ;",
    "info": "SELECT id,username,image_path,viewname FROM user limit 1;",
    "create": "INSERT INTO attendce ( user_id, attendce_time, attendce_date,not_attendce ) VALUES ('{user_id}', '{attendce_time}', '{attendce_date}','{not_attendce}');",
    "delete": "DELETE FROM user WHERE id = '{id}';",
    "update": "INSERT INTO attendce ( user_id, attendce_time, attendce_date ) VALUES ('{user_id}', '{attendce_time}', '{attendce_date}' );",
    "edit": """UPDATE attendce SET user_id = '{user_id}', not_attendce = '{not_attendce}', attendce_date = '{attendce_date}' WHERE id = '{id}';""",
    "later_user": """SELECT
	*
FROM
USER
WHERE
	id NOT IN (
SELECT
	u.id
FROM
	USER u
	INNER JOIN attendce a ON u.id = a.user_id
WHERE
	strftime ( '%m-%d', 'now', 'localtime' ) = strftime ( '%m-%d', a.attendce_time )
	)"""
    
}
